﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<删除客户跟踪IN方式>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Customer_Track_Item_DeleteIn]
(
	@CustomerId VARCHAR(50),
	@IdList VARCHAR(300)
)

AS
DECLARE @str NVARCHAR(3000)
BEGIN
SET @str='
	DELETE FROM Customer_Track WHERE CustomerId='''+@CustomerId+''' AND id IN ('+@IdList+')
	'
EXEC(@str)
SELECT @@ROWCOUNT

END
